How to: Remove protection from a worksheet cell.
Solution:
Select the cell and select 'Cells...' from the 'Format' menu.
1) Select the cell to unprotect.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Protection' tab.
4) Do one or both of the following:
a) Clear the 'Locked' check box to allow changes to the selected cell.
b) Clear the 'Hidden' check box to allow the cell's formula to appear in the formula bar when the cell is selected.
5) Click 'OK'.